﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Entity;
using TeamOPSchoolCup.Domain.POCO;
using TeamOPSchoolCup.Domain.POCO.Members;
using TeamOPSchoolCup.Domain.Services;
using TeamOPSchoolCup.Domain.DTO;
using TeamOPSchoolCup.Domain.POCO.Ranking;
using TeamOPSchoolCup.Domain.POCO.Meetings;

namespace TeamOPSchoolCup.Domain.DAL
{
  //TODO While we're in development mode... Remove from deployment situations!
  public class EFDbContextInitializer : DropCreateDatabaseAlways<EFDbContext>
  {
    protected override void Seed(EFDbContext context)
    {
      base.Seed(context);

      //Creating a unique key on events, because events keep getting added 5 times. This should find me the error.
      context.Database.ExecuteSqlCommand("CREATE UNIQUE INDEX UN_Event_Name ON Event (Name)");

      //As for user, testdata should be made for the subentities
      //Add Coaches
      MemberService.AddCoach(context,new Coach {Member = new Member{Name = "Joske Vermeulen",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="joske@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1972,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddCoach(context,new Coach {Member = new Member{Name = "Anneke Panneke",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="anneke@se2.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1973,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddCoach(context,new Coach {Member = new Member{Name = "Jan Janssens",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="jan@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1974,4,29), PhoneNumber="+32925473658"},Photo="photo"});

      //Add Regions
      RegionService.AddRegion(context,new Region { Name = "North-America", DateJoined = DateTime.Today });
      RegionService.AddRegion(context,new Region { Name = "USA", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context,"North-America") });
      RegionService.AddRegion(context,new Region { Name = "Florida", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context,"USA") });
      RegionService.AddRegion(context, new Region { Name = "New York", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context, "USA") });
      RegionService.AddRegion(context,new Region { Name = "Europe", DateJoined = DateTime.Today });
      RegionService.AddRegion(context, new Region { Name = "Belgium", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context, "Europe") });
      RegionService.AddRegion(context, new Region { Name = "Flanders", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context, "Belgium") });
      RegionService.AddRegion(context, new Region { Name = "Wallonia", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context, "Belgium") });
      RegionService.AddRegion(context, new Region { Name = "Asia", DateJoined = DateTime.Today });
      RegionService.AddRegion(context, new Region { Name = "Japan", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context, "Asia") });
      RegionService.AddRegion(context, new Region { Name = "Hokkaido", DateJoined = DateTime.Today, Parent = RegionService.GetRegion(context, "Japan") });
      
      //Add NSSFs
      NSSFService.AddNSSF(context,new NSSF { Name = "SVS", Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", PhoneNumber="+32925473658",FaxNumber="+32925473658",Email="nssf@svs.be",DateAdded = new DateTime(2012,5,5),Region = context.Regions.Single(r=> r.Name=="New York")});
      NSSFService.AddNSSF(context,new NSSF { Name = "SNS", Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", PhoneNumber="+32925473658",FaxNumber="+32925473658",Email="nssf@sns.be",DateAdded = new DateTime(2012,5,5),Region = context.Regions.Single(r=> r.Name=="Flanders")});        
      NSSFService.AddNSSF(context,new NSSF { Name = "SBS", Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", PhoneNumber="+32925473658",FaxNumber="+32925473658",Email="nssf@sbs.be",DateAdded = new DateTime(2012,5,5),Region = context.Regions.Single(r=> r.Name=="Florida")});
      NSSFService.AddNSSF(context,new NSSF { Name = "TKT", Street = "Zottendijk 5", City = "Antwerpen", Zipcode = "BE-5586", PhoneNumber = "+32925473658", FaxNumber = "+32925473658", Email = "nssf@tkt.be", DateAdded = new DateTime(2012, 5, 5), Region = context.Regions.Single(r => r.Name == "Hokkaido") });
      //Add NSSFReps

      MemberService.AddNSSFRep(context,new NSSFRep {Member = new Member{Name = "Peter Pan",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="peter@svs.be",Gender=Gender.MALE,BirthDate= new DateTime(1972,4,29), PhoneNumber="+32925473658"}},context.NSSFs.Single(n => n.Name == "SVS" ));
      MemberService.AddNSSFRep(context,new NSSFRep {Member = new Member{Name = "Snow White",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="snow@sns.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1973,4,29), PhoneNumber="+32925473658"}},context.NSSFs.Single(n => n.Name == "SBS"));
      MemberService.AddNSSFRep(context,new NSSFRep {Member = new Member{Name = "Klein Duimpje",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="klein@sbs.be",Gender=Gender.MALE,BirthDate= new DateTime(1972,4,29), PhoneNumber="+32925473658"}},context.NSSFs.Single(n => n.Name == "SNS"));
      MemberService.AddNSSFRep(context,new NSSFRep {Member = new Member{Name = "Bruce Lee",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="bruce@tkt.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1973,4,29), PhoneNumber="+32925473658"}},context.NSSFs.Single(n => n.Name == "TKT"));

      //Add SCCs
      MemberService.AddSCC(context,new SCC {Member = new Member{Name = "S1 Test",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s1@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1972,4,29), PhoneNumber="+32925473658"}});
      MemberService.AddSCC(context,new SCC {Member = new Member{Name = "S2 Test",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s2@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1973,4,29), PhoneNumber="+32925473658"}});
      MemberService.AddSCC(context,new SCC {Member = new Member{Name = "S3 Test",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s3@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1972,4,29), PhoneNumber="+32925473658"}});
      MemberService.AddSCC(context,new SCC {Member = new Member{Name = "S4 Test",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s4@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1973,4,29), PhoneNumber="+32925473658"}});

      //Add Students
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S1",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s1@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1995,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S2",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s2@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1996,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S3",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s3@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1997,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S4",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s4@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1998,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S5",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s1@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1995,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S6",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s2@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1996,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S7",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s3@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1997,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S8",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s4@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1998,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S9",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s1@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1995,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S10",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s2@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1996,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S11",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s3@se.be",Gender=Gender.MALE,BirthDate= new DateTime(1997,4,29), PhoneNumber="+32925473658"},Photo="photo"});
      MemberService.AddStudent(context,new Student {Member = new Member{Name = "S12",Street = "Zottendijk 5", City="Antwerpen", Zipcode="BE-5586", Email="s4@se.be",Gender=Gender.FEMALE,BirthDate= new DateTime(1998,4,29), PhoneNumber="+32925473658"},Photo="photo"});

      SportService.AddSport(context,new Sport {Name = "Swimming", Abbreviation = "SWI"});
      SportService.AddSport(context,new Sport {Name = "Athletics", Abbreviation = "ATH"});

      TeamService.AddTeam(context,new Team { Name="De snelle eddies",Photo="photo",Logo="logo",Gender=Gender.MALE,Coach=MemberService.GetCoach(context,"Joske Vermeulen")/*,School= context.Schools.Single(student=> student.Abbreviation=="T1")*/,Sport=SportService.GetSport(context,"ATH")});
      TeamService.AddTeam(context,new Team { Name="Streamliners",Photo="photo",Logo="logo",Gender=Gender.FEMALE,Coach=MemberService.GetCoach(context,"Anneke Panneke")/*,School= context.Schools.Single(student=> student.Abbreviation=="T2")*/,Sport=SportService.GetSport(context,"SWI")});
      TeamService.AddTeam(context,new Team { Name="Prototypes",Photo="photo",Logo="logo",Gender=Gender.MALE,Coach=MemberService.GetCoach(context,"Jan Janssens")/*,School= context.Schools.Single(student=> student.Abbreviation=="T3")*/,Sport=SportService.GetSport(context,"ATH")});

      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "De snelle eddies").TeamId, MemberService.GetStudent(context, "S1").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Streamliners").TeamId, MemberService.GetStudent(context, "S2").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "De snelle eddies").TeamId, MemberService.GetStudent(context, "S3").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Streamliners").TeamId, MemberService.GetStudent(context, "S4").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "De snelle eddies").TeamId, MemberService.GetStudent(context, "S5").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Streamliners").TeamId, MemberService.GetStudent(context, "S6").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Prototypes").TeamId, MemberService.GetStudent(context, "S7").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Streamliners").TeamId, MemberService.GetStudent(context, "S8").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Prototypes").TeamId, MemberService.GetStudent(context, "S9").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Streamliners").TeamId, MemberService.GetStudent(context, "S10").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Prototypes").TeamId, MemberService.GetStudent(context, "S11").StudentId);
      TeamService.AddTeamMembership(context, TeamService.GetTeam(context, "Streamliners").TeamId, MemberService.GetStudent(context, "S12").StudentId);

      //Add Events

      EventService.AddEvent(context,new Event { Name="long-jumping",IsOfficial=true, Unit=Event.EUnit.DISTANCE, Directionality=Event.EDirectionality.ASC, MinimumValue=0, MaximumValue=3, Sport=SportService.GetSport(context,"ATH")});
      EventService.AddEvent(context,new Event { Name="100m baksteenslag",IsOfficial=false,Unit=Event.EUnit.TIME, Directionality=Event.EDirectionality.DESC, MinimumValue=0, MaximumValue=3, Sport=SportService.GetSport(context,"SWI")});
      EventService.AddEvent(context,new Event { Name="100m fly",IsOfficial=true,Unit=Event.EUnit.TIME,Directionality=Event.EDirectionality.DESC,MinimumValue=0,MaximumValue=3, Sport=SportService.GetSport(context,"SWI")});
      EventService.AddEvent(context,new Event { Name="close-jumping",IsOfficial=false,Unit=Event.EUnit.DISTANCE,Directionality=Event.EDirectionality.ASC, MinimumValue=0,MaximumValue=3, Sport=SportService.GetSport(context,"ATH")});


      //this.InsertPoints(context);
      //this.InsertResults(context);
      this.InsertDataForRanking(context);
    }

    private void InsertPoints(EFDbContext db)
    {
      RankingService.AddPoint(db, new Point { PointId = 1, Gender_Value = 0, PointValue = 100, Measure = 2.21, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 2, Gender_Value = 1, PointValue = 100, Measure = 1.85, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 3, Gender_Value = 0, PointValue = 98, Measure = 2.2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 4, Gender_Value = 1, PointValue = 98, Measure = 1.84, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 5, Gender_Value = 0, PointValue = 96, Measure = 2.19, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 6, Gender_Value = 1, PointValue = 96, Measure = 1.83, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 7, Gender_Value = 0, PointValue = 94, Measure = 2.18, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 8, Gender_Value = 1, PointValue = 94, Measure = 1.82, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 9, Gender_Value = 0, PointValue = 92, Measure = 2.17, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 10, Gender_Value = 1, PointValue = 92, Measure = 1.81, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 11, Gender_Value = 0, PointValue = 90, Measure = 2.16, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 12, Gender_Value = 1, PointValue = 90, Measure = 1.8, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 13, Gender_Value = 0, PointValue = 89, Measure = 2.15, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 14, Gender_Value = 1, PointValue = 89, Measure = 1.79, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 15, Gender_Value = 0, PointValue = 88, Measure = 2.14, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 16, Gender_Value = 1, PointValue = 88, Measure = 1.78, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 17, Gender_Value = 0, PointValue = 87, Measure = 2.13, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 18, Gender_Value = 1, PointValue = 87, Measure = 1.77, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 19, Gender_Value = 0, PointValue = 86, Measure = 2.12, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 20, Gender_Value = 1, PointValue = 86, Measure = 1.76, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 21, Gender_Value = 0, PointValue = 85, Measure = 2.11, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 22, Gender_Value = 1, PointValue = 85, Measure = 1.75, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 23, Gender_Value = 0, PointValue = 84, Measure = 2.1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 24, Gender_Value = 1, PointValue = 84, Measure = 1.74, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 25, Gender_Value = 0, PointValue = 83, Measure = 2.09, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 26, Gender_Value = 1, PointValue = 83, Measure = 1.73, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 27, Gender_Value = 0, PointValue = 82, Measure = 2.08, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 28, Gender_Value = 1, PointValue = 82, Measure = 1.72, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 29, Gender_Value = 0, PointValue = 81, Measure = 2.07, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 30, Gender_Value = 1, PointValue = 81, Measure = 1.71, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 31, Gender_Value = 0, PointValue = 80, Measure = 2.06, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 32, Gender_Value = 1, PointValue = 80, Measure = 1.7, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 33, Gender_Value = 0, PointValue = 79, Measure = 2.05, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 34, Gender_Value = 1, PointValue = 79, Measure = 1.69, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 35, Gender_Value = 0, PointValue = 78, Measure = 2.04, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 36, Gender_Value = 1, PointValue = 78, Measure = 1.68, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 37, Gender_Value = 0, PointValue = 77, Measure = 2.03, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 38, Gender_Value = 1, PointValue = 77, Measure = 1.67, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 39, Gender_Value = 0, PointValue = 76, Measure = 2.02, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 40, Gender_Value = 1, PointValue = 76, Measure = 1.66, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 41, Gender_Value = 0, PointValue = 75, Measure = 2.01, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 42, Gender_Value = 1, PointValue = 75, Measure = 1.65, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 43, Gender_Value = 0, PointValue = 74, Measure = 2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 44, Gender_Value = 1, PointValue = 74, Measure = 1.64, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 45, Gender_Value = 0, PointValue = 73, Measure = 1.99, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 46, Gender_Value = 1, PointValue = 73, Measure = 1.63, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 47, Gender_Value = 0, PointValue = 72, Measure = 1.98, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 48, Gender_Value = 1, PointValue = 72, Measure = 1.62, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 49, Gender_Value = 0, PointValue = 71, Measure = 1.97, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 50, Gender_Value = 1, PointValue = 71, Measure = 1.61, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 51, Gender_Value = 0, PointValue = 70, Measure = 1.96, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 52, Gender_Value = 1, PointValue = 70, Measure = 1.6, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 53, Gender_Value = 0, PointValue = 69, Measure = 1.95, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 54, Gender_Value = 1, PointValue = 69, Measure = 1.59, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 55, Gender_Value = 0, PointValue = 68, Measure = 1.94, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 56, Gender_Value = 1, PointValue = 68, Measure = 1.58, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 57, Gender_Value = 0, PointValue = 67, Measure = 1.93, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 58, Gender_Value = 1, PointValue = 67, Measure = 1.57, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 59, Gender_Value = 0, PointValue = 66, Measure = 1.92, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 60, Gender_Value = 1, PointValue = 66, Measure = 1.56, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 61, Gender_Value = 0, PointValue = 65, Measure = 1.91, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 62, Gender_Value = 1, PointValue = 65, Measure = 1.55, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 63, Gender_Value = 0, PointValue = 64, Measure = 1.9, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 64, Gender_Value = 1, PointValue = 64, Measure = 1.54, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 65, Gender_Value = 0, PointValue = 63, Measure = 1.89, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 66, Gender_Value = 1, PointValue = 63, Measure = 1.53, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 67, Gender_Value = 0, PointValue = 62, Measure = 1.88, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 68, Gender_Value = 1, PointValue = 62, Measure = 1.52, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 69, Gender_Value = 0, PointValue = 61, Measure = 1.87, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 70, Gender_Value = 1, PointValue = 61, Measure = 1.51, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 71, Gender_Value = 0, PointValue = 60, Measure = 1.86, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 72, Gender_Value = 1, PointValue = 60, Measure = 1.5, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 73, Gender_Value = 0, PointValue = 59, Measure = 1.85, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 74, Gender_Value = 1, PointValue = 59, Measure = 1.49, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 75, Gender_Value = 0, PointValue = 58, Measure = 1.84, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 76, Gender_Value = 1, PointValue = 58, Measure = 1.48, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 77, Gender_Value = 0, PointValue = 57, Measure = 1.83, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 78, Gender_Value = 1, PointValue = 57, Measure = 1.47, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 79, Gender_Value = 0, PointValue = 56, Measure = 1.82, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 80, Gender_Value = 1, PointValue = 56, Measure = 1.46, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 81, Gender_Value = 0, PointValue = 55, Measure = 1.81, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 82, Gender_Value = 1, PointValue = 55, Measure = 1.45, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 83, Gender_Value = 0, PointValue = 54, Measure = 1.8, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 84, Gender_Value = 1, PointValue = 54, Measure = 1.44, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 85, Gender_Value = 0, PointValue = 53, Measure = 1.79, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 86, Gender_Value = 1, PointValue = 53, Measure = 1.43, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 87, Gender_Value = 0, PointValue = 52, Measure = 1.78, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 88, Gender_Value = 1, PointValue = 52, Measure = 1.42, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 89, Gender_Value = 0, PointValue = 51, Measure = 1.77, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 90, Gender_Value = 1, PointValue = 51, Measure = 1.41, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 91, Gender_Value = 0, PointValue = 50, Measure = 1.76, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 92, Gender_Value = 1, PointValue = 50, Measure = 1.4, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 93, Gender_Value = 0, PointValue = 49, Measure = 1.75, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 94, Gender_Value = 1, PointValue = 49, Measure = 1.39, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 95, Gender_Value = 0, PointValue = 48, Measure = 1.74, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 96, Gender_Value = 1, PointValue = 48, Measure = 1.38, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 97, Gender_Value = 0, PointValue = 47, Measure = 1.73, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 98, Gender_Value = 1, PointValue = 47, Measure = 1.37, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 99, Gender_Value = 0, PointValue = 46, Measure = 1.72, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 100, Gender_Value = 1, PointValue = 46, Measure = 1.36, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 101, Gender_Value = 0, PointValue = 45, Measure = 1.71, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 102, Gender_Value = 1, PointValue = 45, Measure = 1.35, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 103, Gender_Value = 0, PointValue = 44, Measure = 1.7, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 104, Gender_Value = 1, PointValue = 44, Measure = 1.34, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 105, Gender_Value = 0, PointValue = 43, Measure = 1.69, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 106, Gender_Value = 1, PointValue = 43, Measure = 1.33, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 107, Gender_Value = 0, PointValue = 42, Measure = 1.68, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 108, Gender_Value = 1, PointValue = 42, Measure = 1.32, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 109, Gender_Value = 0, PointValue = 41, Measure = 1.67, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 110, Gender_Value = 1, PointValue = 41, Measure = 1.31, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 111, Gender_Value = 0, PointValue = 40, Measure = 1.66, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 112, Gender_Value = 1, PointValue = 40, Measure = 1.3, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 113, Gender_Value = 0, PointValue = 39, Measure = 1.65, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 114, Gender_Value = 1, PointValue = 39, Measure = 1.29, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 115, Gender_Value = 0, PointValue = 38, Measure = 1.64, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 116, Gender_Value = 1, PointValue = 38, Measure = 1.28, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 117, Gender_Value = 0, PointValue = 37, Measure = 1.63, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 118, Gender_Value = 1, PointValue = 37, Measure = 1.27, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 119, Gender_Value = 0, PointValue = 36, Measure = 1.62, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 120, Gender_Value = 1, PointValue = 36, Measure = 1.26, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 121, Gender_Value = 0, PointValue = 35, Measure = 1.61, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 122, Gender_Value = 1, PointValue = 35, Measure = 1.25, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 123, Gender_Value = 0, PointValue = 34, Measure = 1.6, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 124, Gender_Value = 1, PointValue = 34, Measure = 1.24, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 125, Gender_Value = 0, PointValue = 33, Measure = 1.59, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 126, Gender_Value = 1, PointValue = 33, Measure = 1.23, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 127, Gender_Value = 0, PointValue = 32, Measure = 1.58, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 128, Gender_Value = 1, PointValue = 32, Measure = 1.22, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 129, Gender_Value = 0, PointValue = 31, Measure = 1.57, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 130, Gender_Value = 1, PointValue = 31, Measure = 1.2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 131, Gender_Value = 0, PointValue = 30, Measure = 1.56, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 132, Gender_Value = 1, PointValue = 30, Measure = 1.18, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 133, Gender_Value = 0, PointValue = 29, Measure = 1.54, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 134, Gender_Value = 1, PointValue = 29, Measure = 1.16, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 135, Gender_Value = 0, PointValue = 28, Measure = 1.52, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 136, Gender_Value = 1, PointValue = 28, Measure = 1.14, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 137, Gender_Value = 0, PointValue = 27, Measure = 1.5, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 138, Gender_Value = 1, PointValue = 27, Measure = 1.12, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 139, Gender_Value = 0, PointValue = 26, Measure = 1.48, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 140, Gender_Value = 1, PointValue = 26, Measure = 1.1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 141, Gender_Value = 0, PointValue = 25, Measure = 1.46, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 142, Gender_Value = 1, PointValue = 25, Measure = 1.08, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 143, Gender_Value = 0, PointValue = 24, Measure = 1.44, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 144, Gender_Value = 1, PointValue = 24, Measure = 1.06, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 145, Gender_Value = 0, PointValue = 23, Measure = 1.42, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 146, Gender_Value = 1, PointValue = 23, Measure = 1.04, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 147, Gender_Value = 0, PointValue = 22, Measure = 1.4, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 148, Gender_Value = 1, PointValue = 22, Measure = 1.02, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 149, Gender_Value = 0, PointValue = 21, Measure = 1.38, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 150, Gender_Value = 1, PointValue = 21, Measure = 1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 151, Gender_Value = 0, PointValue = 20, Measure = 1.36, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 152, Gender_Value = 1, PointValue = 20, Measure = 0.98, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 153, Gender_Value = 0, PointValue = 19, Measure = 1.34, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 154, Gender_Value = 1, PointValue = 19, Measure = 0.96, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 155, Gender_Value = 0, PointValue = 18, Measure = 1.32, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 156, Gender_Value = 1, PointValue = 18, Measure = 0.94, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 157, Gender_Value = 0, PointValue = 17, Measure = 1.3, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 158, Gender_Value = 1, PointValue = 17, Measure = 0.92, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 159, Gender_Value = 0, PointValue = 16, Measure = 1.28, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 160, Gender_Value = 1, PointValue = 16, Measure = 0.9, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 161, Gender_Value = 0, PointValue = 15, Measure = 1.26, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 162, Gender_Value = 1, PointValue = 15, Measure = 0.88, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 163, Gender_Value = 0, PointValue = 14, Measure = 1.24, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 164, Gender_Value = 1, PointValue = 14, Measure = 0.86, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 165, Gender_Value = 0, PointValue = 13, Measure = 1.22, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 166, Gender_Value = 1, PointValue = 13, Measure = 0.84, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 167, Gender_Value = 0, PointValue = 12, Measure = 1.2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 168, Gender_Value = 1, PointValue = 12, Measure = 0.82, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 169, Gender_Value = 0, PointValue = 11, Measure = 1.18, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 170, Gender_Value = 1, PointValue = 11, Measure = 0.8, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 171, Gender_Value = 0, PointValue = 10, Measure = 1.16, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 172, Gender_Value = 1, PointValue = 10, Measure = 0.78, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 173, Gender_Value = 0, PointValue = 9, Measure = 1.14, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 174, Gender_Value = 1, PointValue = 9, Measure = 0.76, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 175, Gender_Value = 0, PointValue = 8, Measure = 1.12, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 176, Gender_Value = 1, PointValue = 8, Measure = 0.74, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 177, Gender_Value = 0, PointValue = 7, Measure = 1.1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 178, Gender_Value = 1, PointValue = 7, Measure = 0.72, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 179, Gender_Value = 0, PointValue = 6, Measure = 1.08, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 180, Gender_Value = 1, PointValue = 6, Measure = 0.7, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 181, Gender_Value = 0, PointValue = 5, Measure = 1.06, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 182, Gender_Value = 1, PointValue = 5, Measure = 0.68, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 183, Gender_Value = 0, PointValue = 4, Measure = 1.04, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 184, Gender_Value = 1, PointValue = 4, Measure = 0.66, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 185, Gender_Value = 0, PointValue = 3, Measure = 1.02, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 186, Gender_Value = 1, PointValue = 3, Measure = 0.64, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 187, Gender_Value = 0, PointValue = 2, Measure = 1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 188, Gender_Value = 1, PointValue = 2, Measure = 0.62, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 189, Gender_Value = 0, PointValue = 1, Measure = 0.98, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 190, Gender_Value = 1, PointValue = 1, Measure = 0.6, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 191, Gender_Value = 0, PointValue = 100, Measure = 2.21, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 192, Gender_Value = 1, PointValue = 100, Measure = 1.85, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 193, Gender_Value = 0, PointValue = 98, Measure = 2.2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 194, Gender_Value = 1, PointValue = 98, Measure = 1.84, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 195, Gender_Value = 0, PointValue = 96, Measure = 2.19, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 196, Gender_Value = 1, PointValue = 96, Measure = 1.83, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 197, Gender_Value = 0, PointValue = 94, Measure = 2.18, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 198, Gender_Value = 1, PointValue = 94, Measure = 1.82, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 199, Gender_Value = 0, PointValue = 92, Measure = 2.17, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 200, Gender_Value = 1, PointValue = 92, Measure = 1.81, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 201, Gender_Value = 0, PointValue = 90, Measure = 2.16, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 202, Gender_Value = 1, PointValue = 90, Measure = 1.8, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 203, Gender_Value = 0, PointValue = 89, Measure = 2.15, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 204, Gender_Value = 1, PointValue = 89, Measure = 1.79, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 205, Gender_Value = 0, PointValue = 88, Measure = 2.14, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 206, Gender_Value = 1, PointValue = 88, Measure = 1.78, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 207, Gender_Value = 0, PointValue = 87, Measure = 2.13, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 208, Gender_Value = 1, PointValue = 87, Measure = 1.77, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 209, Gender_Value = 0, PointValue = 86, Measure = 2.12, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 210, Gender_Value = 1, PointValue = 86, Measure = 1.76, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 211, Gender_Value = 0, PointValue = 85, Measure = 2.11, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 212, Gender_Value = 1, PointValue = 85, Measure = 1.75, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 213, Gender_Value = 0, PointValue = 84, Measure = 2.1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 214, Gender_Value = 1, PointValue = 84, Measure = 1.74, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 215, Gender_Value = 0, PointValue = 83, Measure = 2.09, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 216, Gender_Value = 1, PointValue = 83, Measure = 1.73, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 217, Gender_Value = 0, PointValue = 82, Measure = 2.08, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 218, Gender_Value = 1, PointValue = 82, Measure = 1.72, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 219, Gender_Value = 0, PointValue = 81, Measure = 2.07, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 220, Gender_Value = 1, PointValue = 81, Measure = 1.71, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 221, Gender_Value = 0, PointValue = 80, Measure = 2.06, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 222, Gender_Value = 1, PointValue = 80, Measure = 1.7, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 223, Gender_Value = 0, PointValue = 79, Measure = 2.05, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 224, Gender_Value = 1, PointValue = 79, Measure = 1.69, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 225, Gender_Value = 0, PointValue = 78, Measure = 2.04, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 226, Gender_Value = 1, PointValue = 78, Measure = 1.68, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 227, Gender_Value = 0, PointValue = 77, Measure = 2.03, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 228, Gender_Value = 1, PointValue = 77, Measure = 1.67, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 229, Gender_Value = 0, PointValue = 76, Measure = 2.02, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 230, Gender_Value = 1, PointValue = 76, Measure = 1.66, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 231, Gender_Value = 0, PointValue = 75, Measure = 2.01, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 232, Gender_Value = 1, PointValue = 75, Measure = 1.65, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 233, Gender_Value = 0, PointValue = 74, Measure = 2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 234, Gender_Value = 1, PointValue = 74, Measure = 1.64, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 235, Gender_Value = 0, PointValue = 73, Measure = 1.99, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 236, Gender_Value = 1, PointValue = 73, Measure = 1.63, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 237, Gender_Value = 0, PointValue = 72, Measure = 1.98, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 238, Gender_Value = 1, PointValue = 72, Measure = 1.62, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 239, Gender_Value = 0, PointValue = 71, Measure = 1.97, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 240, Gender_Value = 1, PointValue = 71, Measure = 1.61, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 241, Gender_Value = 0, PointValue = 70, Measure = 1.96, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 242, Gender_Value = 1, PointValue = 70, Measure = 1.6, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 243, Gender_Value = 0, PointValue = 69, Measure = 1.95, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 244, Gender_Value = 1, PointValue = 69, Measure = 1.59, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 245, Gender_Value = 0, PointValue = 68, Measure = 1.94, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 246, Gender_Value = 1, PointValue = 68, Measure = 1.58, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 247, Gender_Value = 0, PointValue = 67, Measure = 1.93, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 248, Gender_Value = 1, PointValue = 67, Measure = 1.57, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 249, Gender_Value = 0, PointValue = 66, Measure = 1.92, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 250, Gender_Value = 1, PointValue = 66, Measure = 1.56, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 251, Gender_Value = 0, PointValue = 65, Measure = 1.91, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 252, Gender_Value = 1, PointValue = 65, Measure = 1.55, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 253, Gender_Value = 0, PointValue = 64, Measure = 1.9, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 254, Gender_Value = 1, PointValue = 64, Measure = 1.54, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 255, Gender_Value = 0, PointValue = 63, Measure = 1.89, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 256, Gender_Value = 1, PointValue = 63, Measure = 1.53, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 257, Gender_Value = 0, PointValue = 62, Measure = 1.88, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 258, Gender_Value = 1, PointValue = 62, Measure = 1.52, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 259, Gender_Value = 0, PointValue = 61, Measure = 1.87, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 260, Gender_Value = 1, PointValue = 61, Measure = 1.51, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 261, Gender_Value = 0, PointValue = 60, Measure = 1.86, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 262, Gender_Value = 1, PointValue = 60, Measure = 1.5, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 263, Gender_Value = 0, PointValue = 59, Measure = 1.85, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 264, Gender_Value = 1, PointValue = 59, Measure = 1.49, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 265, Gender_Value = 0, PointValue = 58, Measure = 1.84, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 266, Gender_Value = 1, PointValue = 58, Measure = 1.48, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 267, Gender_Value = 0, PointValue = 57, Measure = 1.83, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 268, Gender_Value = 1, PointValue = 57, Measure = 1.47, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 269, Gender_Value = 0, PointValue = 56, Measure = 1.82, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 270, Gender_Value = 1, PointValue = 56, Measure = 1.46, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 271, Gender_Value = 0, PointValue = 55, Measure = 1.81, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 272, Gender_Value = 1, PointValue = 55, Measure = 1.45, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 273, Gender_Value = 0, PointValue = 54, Measure = 1.8, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 274, Gender_Value = 1, PointValue = 54, Measure = 1.44, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 275, Gender_Value = 0, PointValue = 53, Measure = 1.79, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 276, Gender_Value = 1, PointValue = 53, Measure = 1.43, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 277, Gender_Value = 0, PointValue = 52, Measure = 1.78, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 278, Gender_Value = 1, PointValue = 52, Measure = 1.42, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 279, Gender_Value = 0, PointValue = 51, Measure = 1.77, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 280, Gender_Value = 1, PointValue = 51, Measure = 1.41, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 281, Gender_Value = 0, PointValue = 50, Measure = 1.76, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 282, Gender_Value = 1, PointValue = 50, Measure = 1.4, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 283, Gender_Value = 0, PointValue = 49, Measure = 1.75, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 284, Gender_Value = 1, PointValue = 49, Measure = 1.39, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 285, Gender_Value = 0, PointValue = 48, Measure = 1.74, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 286, Gender_Value = 1, PointValue = 48, Measure = 1.38, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 287, Gender_Value = 0, PointValue = 47, Measure = 1.73, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 288, Gender_Value = 1, PointValue = 47, Measure = 1.37, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 289, Gender_Value = 0, PointValue = 46, Measure = 1.72, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 290, Gender_Value = 1, PointValue = 46, Measure = 1.36, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 291, Gender_Value = 0, PointValue = 45, Measure = 1.71, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 292, Gender_Value = 1, PointValue = 45, Measure = 1.35, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 293, Gender_Value = 0, PointValue = 44, Measure = 1.7, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 294, Gender_Value = 1, PointValue = 44, Measure = 1.34, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 295, Gender_Value = 0, PointValue = 43, Measure = 1.69, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 296, Gender_Value = 1, PointValue = 43, Measure = 1.33, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 297, Gender_Value = 0, PointValue = 42, Measure = 1.68, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 298, Gender_Value = 1, PointValue = 42, Measure = 1.32, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 299, Gender_Value = 0, PointValue = 41, Measure = 1.67, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 300, Gender_Value = 1, PointValue = 41, Measure = 1.31, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 301, Gender_Value = 0, PointValue = 40, Measure = 1.66, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 302, Gender_Value = 1, PointValue = 40, Measure = 1.3, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 303, Gender_Value = 0, PointValue = 39, Measure = 1.65, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 304, Gender_Value = 1, PointValue = 39, Measure = 1.29, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 305, Gender_Value = 0, PointValue = 38, Measure = 1.64, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 306, Gender_Value = 1, PointValue = 38, Measure = 1.28, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 307, Gender_Value = 0, PointValue = 37, Measure = 1.63, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 308, Gender_Value = 1, PointValue = 37, Measure = 1.27, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 309, Gender_Value = 0, PointValue = 36, Measure = 1.62, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 310, Gender_Value = 1, PointValue = 36, Measure = 1.26, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 311, Gender_Value = 0, PointValue = 35, Measure = 1.61, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 312, Gender_Value = 1, PointValue = 35, Measure = 1.25, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 313, Gender_Value = 0, PointValue = 34, Measure = 1.6, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 314, Gender_Value = 1, PointValue = 34, Measure = 1.24, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 315, Gender_Value = 0, PointValue = 33, Measure = 1.59, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 316, Gender_Value = 1, PointValue = 33, Measure = 1.23, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 317, Gender_Value = 0, PointValue = 32, Measure = 1.58, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 318, Gender_Value = 1, PointValue = 32, Measure = 1.22, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 319, Gender_Value = 0, PointValue = 31, Measure = 1.57, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 320, Gender_Value = 1, PointValue = 31, Measure = 1.2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 321, Gender_Value = 0, PointValue = 30, Measure = 1.56, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 322, Gender_Value = 1, PointValue = 30, Measure = 1.18, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 323, Gender_Value = 0, PointValue = 29, Measure = 1.54, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 324, Gender_Value = 1, PointValue = 29, Measure = 1.16, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 325, Gender_Value = 0, PointValue = 28, Measure = 1.52, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 326, Gender_Value = 1, PointValue = 28, Measure = 1.14, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 327, Gender_Value = 0, PointValue = 27, Measure = 1.5, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 328, Gender_Value = 1, PointValue = 27, Measure = 1.12, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 329, Gender_Value = 0, PointValue = 26, Measure = 1.48, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 330, Gender_Value = 1, PointValue = 26, Measure = 1.1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 331, Gender_Value = 0, PointValue = 25, Measure = 1.46, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 332, Gender_Value = 1, PointValue = 25, Measure = 1.08, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 333, Gender_Value = 0, PointValue = 24, Measure = 1.44, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 334, Gender_Value = 1, PointValue = 24, Measure = 1.06, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 335, Gender_Value = 0, PointValue = 23, Measure = 1.42, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 336, Gender_Value = 1, PointValue = 23, Measure = 1.04, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 337, Gender_Value = 0, PointValue = 22, Measure = 1.4, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 338, Gender_Value = 1, PointValue = 22, Measure = 1.02, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 339, Gender_Value = 0, PointValue = 21, Measure = 1.38, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 340, Gender_Value = 1, PointValue = 21, Measure = 1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 341, Gender_Value = 0, PointValue = 20, Measure = 1.36, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 342, Gender_Value = 1, PointValue = 20, Measure = 0.98, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 343, Gender_Value = 0, PointValue = 19, Measure = 1.34, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 344, Gender_Value = 1, PointValue = 19, Measure = 0.96, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 345, Gender_Value = 0, PointValue = 18, Measure = 1.32, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 346, Gender_Value = 1, PointValue = 18, Measure = 0.94, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 347, Gender_Value = 0, PointValue = 17, Measure = 1.3, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 348, Gender_Value = 1, PointValue = 17, Measure = 0.92, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 349, Gender_Value = 0, PointValue = 16, Measure = 1.28, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 350, Gender_Value = 1, PointValue = 16, Measure = 0.9, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 351, Gender_Value = 0, PointValue = 15, Measure = 1.26, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 352, Gender_Value = 1, PointValue = 15, Measure = 0.88, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 353, Gender_Value = 0, PointValue = 14, Measure = 1.24, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 354, Gender_Value = 1, PointValue = 14, Measure = 0.86, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 355, Gender_Value = 0, PointValue = 13, Measure = 1.22, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 356, Gender_Value = 1, PointValue = 13, Measure = 0.84, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 357, Gender_Value = 0, PointValue = 12, Measure = 1.2, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 358, Gender_Value = 1, PointValue = 12, Measure = 0.82, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 359, Gender_Value = 0, PointValue = 11, Measure = 1.18, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 360, Gender_Value = 1, PointValue = 11, Measure = 0.8, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 361, Gender_Value = 0, PointValue = 10, Measure = 1.16, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 362, Gender_Value = 1, PointValue = 10, Measure = 0.78, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 363, Gender_Value = 0, PointValue = 9, Measure = 1.14, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 364, Gender_Value = 1, PointValue = 9, Measure = 0.76, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 365, Gender_Value = 0, PointValue = 8, Measure = 1.12, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 366, Gender_Value = 1, PointValue = 8, Measure = 0.74, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 367, Gender_Value = 0, PointValue = 7, Measure = 1.1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 368, Gender_Value = 1, PointValue = 7, Measure = 0.72, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 369, Gender_Value = 0, PointValue = 6, Measure = 1.08, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 370, Gender_Value = 1, PointValue = 6, Measure = 0.7, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 371, Gender_Value = 0, PointValue = 5, Measure = 1.06, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 372, Gender_Value = 1, PointValue = 5, Measure = 0.68, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 373, Gender_Value = 0, PointValue = 4, Measure = 1.04, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 374, Gender_Value = 1, PointValue = 4, Measure = 0.66, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 375, Gender_Value = 0, PointValue = 3, Measure = 1.02, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 376, Gender_Value = 1, PointValue = 3, Measure = 0.64, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 377, Gender_Value = 0, PointValue = 2, Measure = 1, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 378, Gender_Value = 1, PointValue = 2, Measure = 0.62, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 379, Gender_Value = 0, PointValue = 1, Measure = 0.98, CompetitionYear = 2013, EventId = 1 });
      RankingService.AddPoint(db, new Point { PointId = 380, Gender_Value = 1, PointValue = 1, Measure = 0.6, CompetitionYear = 2013, EventId = 1 });
    }
    private void InsertResults(EFDbContext db)
    {
      Event eLJ = EventService.GetEvent(db, "long-jumping");
      Event eCF = EventService.GetEvent(db, "100m fly");
      Event eCB = EventService.GetEvent(db, "100m baksteenslag");
      Event eCJ = EventService.GetEvent(db, "close-jumping");
      ResultService.AddResult(db, new Result { ResultScore = 1.00, Event = eLJ, TeamMembership = MemberService.GetStudent(db,"S1").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.59, Event = eCF, TeamMembership = MemberService.GetStudent(db,"S2").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 1.30, Event = eCB, TeamMembership = MemberService.GetStudent(db,"S3").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.50, Event = eCJ, TeamMembership = MemberService.GetStudent(db,"S4").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 3.00, Event = eLJ, TeamMembership = MemberService.GetStudent(db,"S5").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.50, Event = eCF, TeamMembership = MemberService.GetStudent(db,"S6").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 1.25, Event = eCB, TeamMembership = MemberService.GetStudent(db,"S7").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 1.00, Event = eCJ, TeamMembership = MemberService.GetStudent(db,"S8").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 2.50, Event = eLJ, TeamMembership = MemberService.GetStudent(db,"S9").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.55, Event = eCF, TeamMembership = MemberService.GetStudent(db,"S10").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 2.75, Event = eCB, TeamMembership = MemberService.GetStudent(db,"S11").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.25, Event = eCJ, TeamMembership = MemberService.GetStudent(db,"S12").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 2.43, Event = eLJ, TeamMembership = MemberService.GetStudent(db,"S1").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.57, Event = eCF, TeamMembership = MemberService.GetStudent(db,"S2").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 1.80, Event = eCB, TeamMembership = MemberService.GetStudent(db,"S3").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.33, Event = eCJ, TeamMembership = MemberService.GetStudent(db,"S4").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 2.47, Event = eLJ, TeamMembership = MemberService.GetStudent(db,"S5").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.47, Event = eCF, TeamMembership = MemberService.GetStudent(db,"S6").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 1.99, Event = eCB, TeamMembership = MemberService.GetStudent(db,"S7").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.44, Event = eCJ, TeamMembership = MemberService.GetStudent(db,"S8").TeamMemberShips.First() });
      ResultService.AddResult(db, new Result { ResultScore = 0.44, Event = eCJ, TeamMembership = MemberService.GetStudent(db,"S7").TeamMemberShips.First() });
    }

    //See the TestdataRankings-excelsheet in the docs folder
    private void InsertDataForRanking(EFDbContext db)
    {
      Student s101 = new Student { Member = new Member { Name = "S101", Email = "S101@example.com", Gender = Gender.MALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s102 = new Student { Member = new Member { Name = "S102", Email = "S102@example.com", Gender = Gender.MALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s103 = new Student { Member = new Member { Name = "S103", Email = "S103@example.com", Gender = Gender.MALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s104 = new Student { Member = new Member { Name = "S104", Email = "S104@example.com", Gender = Gender.FEMALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s105 = new Student { Member = new Member { Name = "S105", Email = "S105@example.com", Gender = Gender.FEMALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s106 = new Student { Member = new Member { Name = "S106", Email = "S106@example.com", Gender = Gender.FEMALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s107 = new Student { Member = new Member { Name = "S107", Email = "S107@example.com", Gender = Gender.MALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s108 = new Student { Member = new Member { Name = "S108", Email = "S108@example.com", Gender = Gender.MALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s109 = new Student { Member = new Member { Name = "S109", Email = "S109@example.com", Gender = Gender.MALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s110 = new Student { Member = new Member { Name = "S110", Email = "S110@example.com", Gender = Gender.FEMALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s111 = new Student { Member = new Member { Name = "S111", Email = "S111@example.com", Gender = Gender.FEMALE, BirthDate = new DateTime(1995, 4, 29) } };
      Student s112 = new Student { Member = new Member { Name = "S112", Email = "S112@example.com", Gender = Gender.FEMALE, BirthDate = new DateTime(1995, 4, 29) } };
      new List<Student> { s101, s102, s103, s104, s105, s106, s107, s108, s109, s110, s111, s112 }.ForEach(x => MemberService.AddStudent(db,x));

      Team tAthM1 = new Team { Name = "tAthM1", Sport = SportService.GetSport(db,"ATH"), Gender = Gender.MALE, Coach = MemberService.GetCoaches(db).Where(x => x.Member.Gender == Gender.MALE).First() };
      Team tAthF1 = new Team { Name = "tAthF1", Sport = SportService.GetSport(db,"ATH"), Gender = Gender.FEMALE, Coach = MemberService.GetCoaches(db).Where(x => x.Member.Gender == Gender.FEMALE).First() };
      Team tAthM2 = new Team { Name = "tAthM2", Sport = SportService.GetSport(db,"ATH"), Gender = Gender.MALE, Coach = MemberService.GetCoaches(db).Where(x => x.Member.Gender == Gender.MALE).First() };
      Team tAthF2 = new Team { Name = "tAthF2", Sport = SportService.GetSport(db,"ATH"), Gender = Gender.FEMALE, Coach = MemberService.GetCoaches(db).Where(x => x.Member.Gender == Gender.FEMALE).First() };
      new List<Team> { tAthM1, tAthF1, tAthM2, tAthF2 }.ForEach(x => TeamService.AddTeam(db,x));

      TeamService.AddTeamMembership(db, tAthM1.TeamId, s101.StudentId);
      TeamService.AddTeamMembership(db, tAthM1.TeamId, s102.StudentId);
      TeamService.AddTeamMembership(db, tAthM1.TeamId, s103.StudentId);
      TeamService.AddTeamMembership(db, tAthF1.TeamId, s104.StudentId);
      TeamService.AddTeamMembership(db, tAthF1.TeamId, s105.StudentId);
      TeamService.AddTeamMembership(db, tAthF1.TeamId, s106.StudentId);
      TeamService.AddTeamMembership(db, tAthM2.TeamId, s107.StudentId);
      TeamService.AddTeamMembership(db, tAthM2.TeamId, s108.StudentId);
      TeamService.AddTeamMembership(db, tAthM2.TeamId, s109.StudentId);
      TeamService.AddTeamMembership(db, tAthF2.TeamId, s110.StudentId);
      TeamService.AddTeamMembership(db, tAthF2.TeamId, s111.StudentId);
      TeamService.AddTeamMembership(db, tAthF2.TeamId, s112.StudentId);

      Event athEv1 = new Event { Name = "AthEv1", Directionality = Event.EDirectionality.ASC, Unit = Event.EUnit.DISTANCE, IsOfficial = true, Sport = SportService.GetSport(db,"ATH") };
      Event athEv2 = new Event { Name = "AthEv2", Directionality = Event.EDirectionality.DESC, Unit = Event.EUnit.DISTANCE, IsOfficial = true, Sport = SportService.GetSport(db,"ATH") };
      EventService.AddEvent(db, athEv1);
      EventService.AddEvent(db, athEv2);

      RegionalMeeting meet1 = new RegionalMeeting { Meeting = new Meeting { Date = DateTime.Today, IsOfficial = true, Name = "meet1" }, NSSFRep = MemberService.GetNSSFReps(db).First() };
      RegionalMeeting meet2 = new RegionalMeeting { Meeting = new Meeting { Date = DateTime.Today, IsOfficial = true, Name = "meet2" }, NSSFRep = MemberService.GetNSSFReps(db).First() };
      db.RegionalMeetings.Add(meet1);
      db.RegionalMeetings.Add(meet2);
      db.SaveChanges();

      PointsImport piAthEv1 = new PointsImport
      {
        CompetitionYear = 2013,
        Event = athEv1,
        Lines = new List<PointsImport.ImportLine>
        {
					new PointsImport.ImportLine { PointValue=100, BoysMeasure=2.21, GirlsMeasure=1.85 },
					new PointsImport.ImportLine { PointValue=98, BoysMeasure=2.2, GirlsMeasure=1.84 },
					new PointsImport.ImportLine { PointValue=96, BoysMeasure=2.19, GirlsMeasure=1.83 },
					new PointsImport.ImportLine { PointValue=94, BoysMeasure=2.18, GirlsMeasure=1.82 },
					new PointsImport.ImportLine { PointValue=92, BoysMeasure=2.17, GirlsMeasure=1.81 },
					new PointsImport.ImportLine { PointValue=90, BoysMeasure=2.16, GirlsMeasure=1.8 },
					new PointsImport.ImportLine { PointValue=89, BoysMeasure=2.15, GirlsMeasure=1.79 },
					new PointsImport.ImportLine { PointValue=88, BoysMeasure=2.14, GirlsMeasure=1.78 },
					new PointsImport.ImportLine { PointValue=87, BoysMeasure=2.13, GirlsMeasure=1.77 },
					new PointsImport.ImportLine { PointValue=86, BoysMeasure=2.12, GirlsMeasure=1.76 },
					new PointsImport.ImportLine { PointValue=85, BoysMeasure=2.11, GirlsMeasure=1.75 },
					new PointsImport.ImportLine { PointValue=84, BoysMeasure=2.1, GirlsMeasure=1.74 },
					new PointsImport.ImportLine { PointValue=83, BoysMeasure=2.09, GirlsMeasure=1.73 },
					new PointsImport.ImportLine { PointValue=82, BoysMeasure=2.08, GirlsMeasure=1.72 },
					new PointsImport.ImportLine { PointValue=81, BoysMeasure=2.07, GirlsMeasure=1.71 },
					new PointsImport.ImportLine { PointValue=80, BoysMeasure=2.06, GirlsMeasure=1.7 },
					new PointsImport.ImportLine { PointValue=79, BoysMeasure=2.05, GirlsMeasure=1.69 },
					new PointsImport.ImportLine { PointValue=78, BoysMeasure=2.04, GirlsMeasure=1.68 },
					new PointsImport.ImportLine { PointValue=77, BoysMeasure=2.03, GirlsMeasure=1.67 },
					new PointsImport.ImportLine { PointValue=76, BoysMeasure=2.02, GirlsMeasure=1.66 },
					new PointsImport.ImportLine { PointValue=75, BoysMeasure=2.01, GirlsMeasure=1.65 },
					new PointsImport.ImportLine { PointValue=74, BoysMeasure=2, GirlsMeasure=1.64 },
					new PointsImport.ImportLine { PointValue=73, BoysMeasure=1.99, GirlsMeasure=1.63 },
					new PointsImport.ImportLine { PointValue=72, BoysMeasure=1.98, GirlsMeasure=1.62 },
					new PointsImport.ImportLine { PointValue=71, BoysMeasure=1.97, GirlsMeasure=1.61 },
					new PointsImport.ImportLine { PointValue=70, BoysMeasure=1.96, GirlsMeasure=1.6 },
					new PointsImport.ImportLine { PointValue=69, BoysMeasure=1.95, GirlsMeasure=1.59 },
					new PointsImport.ImportLine { PointValue=68, BoysMeasure=1.94, GirlsMeasure=1.58 },
					new PointsImport.ImportLine { PointValue=67, BoysMeasure=1.93, GirlsMeasure=1.57 },
					new PointsImport.ImportLine { PointValue=66, BoysMeasure=1.92, GirlsMeasure=1.56 },
					new PointsImport.ImportLine { PointValue=65, BoysMeasure=1.91, GirlsMeasure=1.55 },
					new PointsImport.ImportLine { PointValue=64, BoysMeasure=1.9, GirlsMeasure=1.54 },
					new PointsImport.ImportLine { PointValue=63, BoysMeasure=1.89, GirlsMeasure=1.53 },
					new PointsImport.ImportLine { PointValue=62, BoysMeasure=1.88, GirlsMeasure=1.52 },
					new PointsImport.ImportLine { PointValue=61, BoysMeasure=1.87, GirlsMeasure=1.51 },
					new PointsImport.ImportLine { PointValue=60, BoysMeasure=1.86, GirlsMeasure=1.5 },
					new PointsImport.ImportLine { PointValue=59, BoysMeasure=1.85, GirlsMeasure=1.49 },
					new PointsImport.ImportLine { PointValue=58, BoysMeasure=1.84, GirlsMeasure=1.48 },
					new PointsImport.ImportLine { PointValue=57, BoysMeasure=1.83, GirlsMeasure=1.47 },
					new PointsImport.ImportLine { PointValue=56, BoysMeasure=1.82, GirlsMeasure=1.46 },
					new PointsImport.ImportLine { PointValue=55, BoysMeasure=1.81, GirlsMeasure=1.45 },
					new PointsImport.ImportLine { PointValue=54, BoysMeasure=1.8, GirlsMeasure=1.44 },
					new PointsImport.ImportLine { PointValue=53, BoysMeasure=1.79, GirlsMeasure=1.43 },
					new PointsImport.ImportLine { PointValue=52, BoysMeasure=1.78, GirlsMeasure=1.42 },
					new PointsImport.ImportLine { PointValue=51, BoysMeasure=1.77, GirlsMeasure=1.41 },
					new PointsImport.ImportLine { PointValue=50, BoysMeasure=1.76, GirlsMeasure=1.4 },
					new PointsImport.ImportLine { PointValue=49, BoysMeasure=1.75, GirlsMeasure=1.39 },
					new PointsImport.ImportLine { PointValue=48, BoysMeasure=1.74, GirlsMeasure=1.38 },
					new PointsImport.ImportLine { PointValue=47, BoysMeasure=1.73, GirlsMeasure=1.37 },
					new PointsImport.ImportLine { PointValue=46, BoysMeasure=1.72, GirlsMeasure=1.36 },
					new PointsImport.ImportLine { PointValue=45, BoysMeasure=1.71, GirlsMeasure=1.35 },
					new PointsImport.ImportLine { PointValue=44, BoysMeasure=1.7, GirlsMeasure=1.34 },
					new PointsImport.ImportLine { PointValue=43, BoysMeasure=1.69, GirlsMeasure=1.33 },
					new PointsImport.ImportLine { PointValue=42, BoysMeasure=1.68, GirlsMeasure=1.32 },
					new PointsImport.ImportLine { PointValue=41, BoysMeasure=1.67, GirlsMeasure=1.31 },
					new PointsImport.ImportLine { PointValue=40, BoysMeasure=1.66, GirlsMeasure=1.3 },
					new PointsImport.ImportLine { PointValue=39, BoysMeasure=1.65, GirlsMeasure=1.29 },
					new PointsImport.ImportLine { PointValue=38, BoysMeasure=1.64, GirlsMeasure=1.28 },
					new PointsImport.ImportLine { PointValue=37, BoysMeasure=1.63, GirlsMeasure=1.27 },
					new PointsImport.ImportLine { PointValue=36, BoysMeasure=1.62, GirlsMeasure=1.26 },
					new PointsImport.ImportLine { PointValue=35, BoysMeasure=1.61, GirlsMeasure=1.25 },
					new PointsImport.ImportLine { PointValue=34, BoysMeasure=1.6, GirlsMeasure=1.24 },
					new PointsImport.ImportLine { PointValue=33, BoysMeasure=1.59, GirlsMeasure=1.23 },
					new PointsImport.ImportLine { PointValue=32, BoysMeasure=1.58, GirlsMeasure=1.22 },
					new PointsImport.ImportLine { PointValue=31, BoysMeasure=1.57, GirlsMeasure=1.2 },
					new PointsImport.ImportLine { PointValue=30, BoysMeasure=1.56, GirlsMeasure=1.18 },
					new PointsImport.ImportLine { PointValue=29, BoysMeasure=1.54, GirlsMeasure=1.16 },
					new PointsImport.ImportLine { PointValue=28, BoysMeasure=1.52, GirlsMeasure=1.14 },
					new PointsImport.ImportLine { PointValue=27, BoysMeasure=1.5, GirlsMeasure=1.12 },
					new PointsImport.ImportLine { PointValue=26, BoysMeasure=1.48, GirlsMeasure=1.1 },
					new PointsImport.ImportLine { PointValue=25, BoysMeasure=1.46, GirlsMeasure=1.08 },
					new PointsImport.ImportLine { PointValue=24, BoysMeasure=1.44, GirlsMeasure=1.06 },
					new PointsImport.ImportLine { PointValue=23, BoysMeasure=1.42, GirlsMeasure=1.04 },
					new PointsImport.ImportLine { PointValue=22, BoysMeasure=1.4, GirlsMeasure=1.02 },
					new PointsImport.ImportLine { PointValue=21, BoysMeasure=1.38, GirlsMeasure=1 },
					new PointsImport.ImportLine { PointValue=20, BoysMeasure=1.36, GirlsMeasure=0.98 },
					new PointsImport.ImportLine { PointValue=19, BoysMeasure=1.34, GirlsMeasure=0.96 },
					new PointsImport.ImportLine { PointValue=18, BoysMeasure=1.32, GirlsMeasure=0.94 },
					new PointsImport.ImportLine { PointValue=17, BoysMeasure=1.3, GirlsMeasure=0.92 },
					new PointsImport.ImportLine { PointValue=16, BoysMeasure=1.28, GirlsMeasure=0.9 },
					new PointsImport.ImportLine { PointValue=15, BoysMeasure=1.26, GirlsMeasure=0.88 },
					new PointsImport.ImportLine { PointValue=14, BoysMeasure=1.24, GirlsMeasure=0.86 },
					new PointsImport.ImportLine { PointValue=13, BoysMeasure=1.22, GirlsMeasure=0.84 },
					new PointsImport.ImportLine { PointValue=12, BoysMeasure=1.2, GirlsMeasure=0.82 },
					new PointsImport.ImportLine { PointValue=11, BoysMeasure=1.18, GirlsMeasure=0.8 },
					new PointsImport.ImportLine { PointValue=10, BoysMeasure=1.16, GirlsMeasure=0.78 },
					new PointsImport.ImportLine { PointValue=9, BoysMeasure=1.14, GirlsMeasure=0.76 },
					new PointsImport.ImportLine { PointValue=8, BoysMeasure=1.12, GirlsMeasure=0.74 },
					new PointsImport.ImportLine { PointValue=7, BoysMeasure=1.1, GirlsMeasure=0.72 },
					new PointsImport.ImportLine { PointValue=6, BoysMeasure=1.08, GirlsMeasure=0.7 },
					new PointsImport.ImportLine { PointValue=5, BoysMeasure=1.06, GirlsMeasure=0.68 },
					new PointsImport.ImportLine { PointValue=4, BoysMeasure=1.04, GirlsMeasure=0.66 },
					new PointsImport.ImportLine { PointValue=3, BoysMeasure=1.02, GirlsMeasure=0.64 },
					new PointsImport.ImportLine { PointValue=2, BoysMeasure=1, GirlsMeasure=0.62 },
					new PointsImport.ImportLine { PointValue=1, BoysMeasure=0.98, GirlsMeasure=0.6 },
        }
      };

      RankingService.ImportPoints(db, piAthEv1);

      PointsImport piAthEv2 = new PointsImport
      {
        CompetitionYear = 2013,
        Event = athEv2,
        Lines = new List<PointsImport.ImportLine>
        {
					new PointsImport.ImportLine { PointValue=100, BoysMeasure=0.98, GirlsMeasure=0.6 },
					new PointsImport.ImportLine { PointValue=98, BoysMeasure=1, GirlsMeasure=0.62 },
					new PointsImport.ImportLine { PointValue=96, BoysMeasure=1.02, GirlsMeasure=0.64 },
					new PointsImport.ImportLine { PointValue=94, BoysMeasure=1.04, GirlsMeasure=0.66 },
					new PointsImport.ImportLine { PointValue=92, BoysMeasure=1.06, GirlsMeasure=0.68 },
					new PointsImport.ImportLine { PointValue=90, BoysMeasure=1.08, GirlsMeasure=0.7 },
					new PointsImport.ImportLine { PointValue=89, BoysMeasure=1.1, GirlsMeasure=0.72 },
					new PointsImport.ImportLine { PointValue=88, BoysMeasure=1.12, GirlsMeasure=0.74 },
					new PointsImport.ImportLine { PointValue=87, BoysMeasure=1.14, GirlsMeasure=0.76 },
					new PointsImport.ImportLine { PointValue=86, BoysMeasure=1.16, GirlsMeasure=0.78 },
					new PointsImport.ImportLine { PointValue=85, BoysMeasure=1.18, GirlsMeasure=0.8 },
					new PointsImport.ImportLine { PointValue=84, BoysMeasure=1.2, GirlsMeasure=0.82 },
					new PointsImport.ImportLine { PointValue=83, BoysMeasure=1.22, GirlsMeasure=0.84 },
					new PointsImport.ImportLine { PointValue=82, BoysMeasure=1.24, GirlsMeasure=0.86 },
					new PointsImport.ImportLine { PointValue=81, BoysMeasure=1.26, GirlsMeasure=0.88 },
					new PointsImport.ImportLine { PointValue=80, BoysMeasure=1.28, GirlsMeasure=0.9 },
					new PointsImport.ImportLine { PointValue=79, BoysMeasure=1.3, GirlsMeasure=0.92 },
					new PointsImport.ImportLine { PointValue=78, BoysMeasure=1.32, GirlsMeasure=0.94 },
					new PointsImport.ImportLine { PointValue=77, BoysMeasure=1.34, GirlsMeasure=0.96 },
					new PointsImport.ImportLine { PointValue=76, BoysMeasure=1.36, GirlsMeasure=0.98 },
					new PointsImport.ImportLine { PointValue=75, BoysMeasure=1.38, GirlsMeasure=1 },
					new PointsImport.ImportLine { PointValue=74, BoysMeasure=1.4, GirlsMeasure=1.02 },
					new PointsImport.ImportLine { PointValue=73, BoysMeasure=1.42, GirlsMeasure=1.04 },
					new PointsImport.ImportLine { PointValue=72, BoysMeasure=1.44, GirlsMeasure=1.06 },
					new PointsImport.ImportLine { PointValue=71, BoysMeasure=1.46, GirlsMeasure=1.08 },
					new PointsImport.ImportLine { PointValue=70, BoysMeasure=1.48, GirlsMeasure=1.1 },
					new PointsImport.ImportLine { PointValue=69, BoysMeasure=1.5, GirlsMeasure=1.12 },
					new PointsImport.ImportLine { PointValue=68, BoysMeasure=1.52, GirlsMeasure=1.14 },
					new PointsImport.ImportLine { PointValue=67, BoysMeasure=1.54, GirlsMeasure=1.16 },
					new PointsImport.ImportLine { PointValue=66, BoysMeasure=1.56, GirlsMeasure=1.18 },
					new PointsImport.ImportLine { PointValue=65, BoysMeasure=1.57, GirlsMeasure=1.2 },
					new PointsImport.ImportLine { PointValue=64, BoysMeasure=1.58, GirlsMeasure=1.22 },
					new PointsImport.ImportLine { PointValue=63, BoysMeasure=1.59, GirlsMeasure=1.23 },
					new PointsImport.ImportLine { PointValue=62, BoysMeasure=1.6, GirlsMeasure=1.24 },
					new PointsImport.ImportLine { PointValue=61, BoysMeasure=1.61, GirlsMeasure=1.25 },
					new PointsImport.ImportLine { PointValue=60, BoysMeasure=1.62, GirlsMeasure=1.26 },
					new PointsImport.ImportLine { PointValue=59, BoysMeasure=1.63, GirlsMeasure=1.27 },
					new PointsImport.ImportLine { PointValue=58, BoysMeasure=1.64, GirlsMeasure=1.28 },
					new PointsImport.ImportLine { PointValue=57, BoysMeasure=1.65, GirlsMeasure=1.29 },
					new PointsImport.ImportLine { PointValue=56, BoysMeasure=1.66, GirlsMeasure=1.3 },
					new PointsImport.ImportLine { PointValue=55, BoysMeasure=1.67, GirlsMeasure=1.31 },
					new PointsImport.ImportLine { PointValue=54, BoysMeasure=1.68, GirlsMeasure=1.32 },
					new PointsImport.ImportLine { PointValue=53, BoysMeasure=1.69, GirlsMeasure=1.33 },
					new PointsImport.ImportLine { PointValue=52, BoysMeasure=1.7, GirlsMeasure=1.34 },
					new PointsImport.ImportLine { PointValue=51, BoysMeasure=1.71, GirlsMeasure=1.35 },
					new PointsImport.ImportLine { PointValue=50, BoysMeasure=1.72, GirlsMeasure=1.36 },
					new PointsImport.ImportLine { PointValue=49, BoysMeasure=1.73, GirlsMeasure=1.37 },
					new PointsImport.ImportLine { PointValue=48, BoysMeasure=1.74, GirlsMeasure=1.38 },
					new PointsImport.ImportLine { PointValue=47, BoysMeasure=1.75, GirlsMeasure=1.39 },
					new PointsImport.ImportLine { PointValue=46, BoysMeasure=1.76, GirlsMeasure=1.4 },
					new PointsImport.ImportLine { PointValue=45, BoysMeasure=1.77, GirlsMeasure=1.41 },
					new PointsImport.ImportLine { PointValue=44, BoysMeasure=1.78, GirlsMeasure=1.42 },
					new PointsImport.ImportLine { PointValue=43, BoysMeasure=1.79, GirlsMeasure=1.43 },
					new PointsImport.ImportLine { PointValue=42, BoysMeasure=1.8, GirlsMeasure=1.44 },
					new PointsImport.ImportLine { PointValue=41, BoysMeasure=1.81, GirlsMeasure=1.45 },
					new PointsImport.ImportLine { PointValue=40, BoysMeasure=1.82, GirlsMeasure=1.46 },
					new PointsImport.ImportLine { PointValue=39, BoysMeasure=1.83, GirlsMeasure=1.47 },
					new PointsImport.ImportLine { PointValue=38, BoysMeasure=1.84, GirlsMeasure=1.48 },
					new PointsImport.ImportLine { PointValue=37, BoysMeasure=1.85, GirlsMeasure=1.49 },
					new PointsImport.ImportLine { PointValue=36, BoysMeasure=1.86, GirlsMeasure=1.5 },
					new PointsImport.ImportLine { PointValue=35, BoysMeasure=1.87, GirlsMeasure=1.51 },
					new PointsImport.ImportLine { PointValue=34, BoysMeasure=1.88, GirlsMeasure=1.52 },
					new PointsImport.ImportLine { PointValue=33, BoysMeasure=1.89, GirlsMeasure=1.53 },
					new PointsImport.ImportLine { PointValue=32, BoysMeasure=1.9, GirlsMeasure=1.54 },
					new PointsImport.ImportLine { PointValue=31, BoysMeasure=1.91, GirlsMeasure=1.55 },
					new PointsImport.ImportLine { PointValue=30, BoysMeasure=1.92, GirlsMeasure=1.56 },
					new PointsImport.ImportLine { PointValue=29, BoysMeasure=1.93, GirlsMeasure=1.57 },
					new PointsImport.ImportLine { PointValue=28, BoysMeasure=1.94, GirlsMeasure=1.58 },
					new PointsImport.ImportLine { PointValue=27, BoysMeasure=1.95, GirlsMeasure=1.59 },
					new PointsImport.ImportLine { PointValue=26, BoysMeasure=1.96, GirlsMeasure=1.6 },
					new PointsImport.ImportLine { PointValue=25, BoysMeasure=1.97, GirlsMeasure=1.61 },
					new PointsImport.ImportLine { PointValue=24, BoysMeasure=1.98, GirlsMeasure=1.62 },
					new PointsImport.ImportLine { PointValue=23, BoysMeasure=1.99, GirlsMeasure=1.63 },
					new PointsImport.ImportLine { PointValue=22, BoysMeasure=2, GirlsMeasure=1.64 },
					new PointsImport.ImportLine { PointValue=21, BoysMeasure=2.01, GirlsMeasure=1.65 },
					new PointsImport.ImportLine { PointValue=20, BoysMeasure=2.02, GirlsMeasure=1.66 },
					new PointsImport.ImportLine { PointValue=19, BoysMeasure=2.03, GirlsMeasure=1.67 },
					new PointsImport.ImportLine { PointValue=18, BoysMeasure=2.04, GirlsMeasure=1.68 },
					new PointsImport.ImportLine { PointValue=17, BoysMeasure=2.05, GirlsMeasure=1.69 },
					new PointsImport.ImportLine { PointValue=16, BoysMeasure=2.06, GirlsMeasure=1.7 },
					new PointsImport.ImportLine { PointValue=15, BoysMeasure=2.07, GirlsMeasure=1.71 },
					new PointsImport.ImportLine { PointValue=14, BoysMeasure=2.08, GirlsMeasure=1.72 },
					new PointsImport.ImportLine { PointValue=13, BoysMeasure=2.09, GirlsMeasure=1.73 },
					new PointsImport.ImportLine { PointValue=12, BoysMeasure=2.1, GirlsMeasure=1.74 },
					new PointsImport.ImportLine { PointValue=11, BoysMeasure=2.11, GirlsMeasure=1.75 },
					new PointsImport.ImportLine { PointValue=10, BoysMeasure=2.12, GirlsMeasure=1.76 },
					new PointsImport.ImportLine { PointValue=9, BoysMeasure=2.13, GirlsMeasure=1.77 },
					new PointsImport.ImportLine { PointValue=8, BoysMeasure=2.14, GirlsMeasure=1.78 },
					new PointsImport.ImportLine { PointValue=7, BoysMeasure=2.15, GirlsMeasure=1.79 },
					new PointsImport.ImportLine { PointValue=6, BoysMeasure=2.16, GirlsMeasure=1.8 },
					new PointsImport.ImportLine { PointValue=5, BoysMeasure=2.17, GirlsMeasure=1.81 },
					new PointsImport.ImportLine { PointValue=4, BoysMeasure=2.18, GirlsMeasure=1.82 },
					new PointsImport.ImportLine { PointValue=3, BoysMeasure=2.19, GirlsMeasure=1.83 },
					new PointsImport.ImportLine { PointValue=2, BoysMeasure=2.2, GirlsMeasure=1.84 },
					new PointsImport.ImportLine { PointValue=1, BoysMeasure=2.21, GirlsMeasure=1.85 },
        }
      };

      RankingService.ImportPoints(db, piAthEv2);

      List<Result> meet1Results = new List<Result>
      {
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s101.StudentId).First(), ResultScore=1.77 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s102.StudentId).First(), ResultScore=1.36 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s103.StudentId).First(), ResultScore=1.82 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s104.StudentId).First(), ResultScore=0.84 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s105.StudentId).First(), ResultScore=0.82 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s106.StudentId).First(), ResultScore=1.81 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s107.StudentId).First(), ResultScore=2.21 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s108.StudentId).First(), ResultScore=1.57 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s109.StudentId).First(), ResultScore=1.12 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s110.StudentId).First(), ResultScore=1.77 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s111.StudentId).First(), ResultScore=1.37 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s112.StudentId).First(), ResultScore=0.96 },

        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s101.StudentId).First(), ResultScore=1.92 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s102.StudentId).First(), ResultScore=2.05 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s103.StudentId).First(), ResultScore=1.20 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s104.StudentId).First(), ResultScore=1.29 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s105.StudentId).First(), ResultScore=1.64 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s106.StudentId).First(), ResultScore=1.14 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s107.StudentId).First(), ResultScore=1.70 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s108.StudentId).First(), ResultScore=1.36 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s109.StudentId).First(), ResultScore=2.00 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s110.StudentId).First(), ResultScore=0.42 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s111.StudentId).First(), ResultScore=1.07 },
        new Result { MeetingId=meet1.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s112.StudentId).First(), ResultScore=0.70 },
      };
      ResultService.AddResults(db, meet1Results, meet1.Meeting);

      List<Result> meet2Results = new List<Result>
      {
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s101.StudentId).First(), ResultScore=1.44 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s102.StudentId).First(), ResultScore=2.19 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s103.StudentId).First(), ResultScore=1.18 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s104.StudentId).First(), ResultScore=1.12 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s105.StudentId).First(), ResultScore=0.94 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s106.StudentId).First(), ResultScore=1.50 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s107.StudentId).First(), ResultScore=2.16 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s108.StudentId).First(), ResultScore=2.01 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s109.StudentId).First(), ResultScore=1.14 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s110.StudentId).First(), ResultScore=1.30 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s111.StudentId).First(), ResultScore=1.02 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv1, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s112.StudentId).First(), ResultScore=1.73 },

        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s101.StudentId).First(), ResultScore=2.14 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s102.StudentId).First(), ResultScore=1.30 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s103.StudentId).First(), ResultScore=2.10 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s104.StudentId).First(), ResultScore=1.52 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s105.StudentId).First(), ResultScore=0.88 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s106.StudentId).First(), ResultScore=1.82 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s107.StudentId).First(), ResultScore=1.99 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s108.StudentId).First(), ResultScore=1.63 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s109.StudentId).First(), ResultScore=2.03 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s110.StudentId).First(), ResultScore=0.78 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s111.StudentId).First(), ResultScore=1.41 },
        new Result { MeetingId=meet2.MeetingId, Event=athEv2, TeamMembership=TeamService.GetTeamMembershipsByStudent(db,s112.StudentId).First(), ResultScore=1.57 },
      };
      ResultService.AddResults(db, meet2Results, meet2.Meeting);
    }
  }
}
